﻿
CREATE	FUNCTION fn_GetComprehensiveLastModified
(	 
	@node_id INT 
)
RETURNS DATETIME
AS
/***********************************************
'
' Boogaloo® - http://www.mindfly.com
' Copyright (c) 2008
' by Mindfly, Inc.
'
' Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
' documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
' the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
' to permit persons to whom the Software is furnished to do so, subject to the following conditions:
'
' The above copyright notice and this permission notice shall be included in all copies or substantial portions 
' of the Software.
'
' THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
' INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
' DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
' SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
' SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
' WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
' THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

************************************************/
BEGIN
	DECLARE @max_date	DATETIME

	SET @max_date = (
	SELECT TOP 1 T1.last_modified_date
	FROM
	(SELECT	node_id
		 ,	last_modified_date
	FROM	boogaloo_node_tbl

	UNION

	SELECT	node_id
		 ,	last_modified_date
	FROM	boogaloo_nodecontrol_tbl

	UNION

	SELECT	T2.node_id
		 ,	T1.last_modified_date
	FROM	boogaloo_nodecontrol_html_ext T1 (NOLOCK)
	JOIN	boogaloo_nodecontrol_tbl T2 (NOLOCK) ON T1.node_control_id = T2.node_control_id) T1
	WHERE node_id = @node_id
	ORDER BY T1.last_modified_date DESC
	)
	
	RETURN @max_date
END 